Overview
Brought to you by YData
Dataset statistics
| Number of variables | 17 |
|---|---|
| Number of observations | 189516 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 82.9 MiB |
| Average record size in memory | 458.7 B |
Variable types
| Numeric | 10 |
|---|---|
| Categorical | 6 |
| Text | 1 |
Cluster_DBSCAN is highly overall correlated with add_to_cart_order and 1 other fields | High correlation |
add_to_cart_order is highly overall correlated with Cluster_DBSCAN | High correlation |
day is highly overall correlated with order_dow | High correlation |
department is highly overall correlated with department_id | High correlation |
department_id is highly overall correlated with department | High correlation |
max_order is highly overall correlated with order_number and 1 other fields | High correlation |
order_dow is highly overall correlated with day | High correlation |
order_hour_of_day is highly overall correlated with order_time_list | High correlation |
order_number is highly overall correlated with max_order and 1 other fields | High correlation |
order_number_group is highly overall correlated with max_order and 1 other fields | High correlation |
order_time_list is highly overall correlated with order_hour_of_day | High correlation |
reordered is highly overall correlated with Cluster_DBSCAN | High correlation |
order_dow has 36565 (19.3%) zeros | Zeros |
days_since_prior_order has 2723 (1.4%) zeros | Zeros |
Reproduction
| Analysis started | 2024-11-07 01:03:50.134226 |
|---|---|
| Analysis finished | 2024-11-07 01:04:06.882990 |
| Duration | 16.75 seconds |
| Software version | ydata-profiling vv4.12.0 |
| Download configuration | config.json |
Variables
order_id
Real number (ℝ)
| Distinct | 106346 |
|---|---|
| Distinct (%) | 56.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1707147.1 |
| Minimum | 10 |
|---|---|
| Maximum | 3420991 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 10 |
|---|---|
| 5-th percentile | 173219.75 |
| Q1 | 850455.5 |
| median | 1706160 |
| Q3 | 2558574.8 |
| 95-th percentile | 3243192 |
| Maximum | 3420991 |
| Range | 3420981 |
| Interquartile range (IQR) | 1708119.2 |
Descriptive statistics
| Standard deviation | 985588.47 |
|---|---|
| Coefficient of variation (CV) | 0.57733074 |
| Kurtosis | -1.199088 |
| Mean | 1707147.1 |
| Median Absolute Deviation (MAD) | 853927 |
| Skewness | 0.0034271321 |
| Sum | 3.2353168 × 1011 |
| Variance | 9.7138463 × 1011 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 45973 | 15 | < 0.1% |
| 790903 | 14 | < 0.1% |
| 2869702 | 12 | < 0.1% |
| 2988851 | 12 | < 0.1% |
| 2621625 | 11 | < 0.1% |
| 2352182 | 11 | < 0.1% |
| 432719 | 11 | < 0.1% |
| 1019050 | 11 | < 0.1% |
| 293169 | 10 | < 0.1% |
| 3269518 | 10 | < 0.1% |
| Other values (106336) | 189399 |
| Value | Count | Frequency (%) |
| 10 | 2 | |
| 11 | 1 | < 0.1% |
| 38 | 1 | < 0.1% |
| 56 | 1 | < 0.1% |
| 64 | 1 | < 0.1% |
| 147 | 2 | |
| 227 | 1 | < 0.1% |
| 243 | 1 | < 0.1% |
| 372 | 1 | < 0.1% |
| 471 | 3 |
| Value | Count | Frequency (%) |
| 3420991 | 3 | |
| 3420952 | 1 | < 0.1% |
| 3420910 | 2 | |
| 3420899 | 1 | < 0.1% |
| 3420898 | 1 | < 0.1% |
| 3420861 | 2 | |
| 3420771 | 4 | |
| 3420760 | 3 | |
| 3420584 | 2 | |
| 3420542 | 2 |
user_id
Real number (ℝ)
| Distinct | 68153 |
|---|---|
| Distinct (%) | 36.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 103102.85 |
| Minimum | 2 |
|---|---|
| Maximum | 206209 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 10750 |
| Q1 | 51690 |
| median | 102860.5 |
| Q3 | 154590.5 |
| 95-th percentile | 195822 |
| Maximum | 206209 |
| Range | 206207 |
| Interquartile range (IQR) | 102900.5 |
Descriptive statistics
| Standard deviation | 59479.667 |
|---|---|
| Coefficient of variation (CV) | 0.57689647 |
| Kurtosis | -1.2034919 |
| Mean | 103102.85 |
| Median Absolute Deviation (MAD) | 51467.5 |
| Skewness | 0.0061718094 |
| Sum | 1.9539639 × 1010 |
| Variance | 3.5378308 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 176478 | 52 | < 0.1% |
| 126305 | 41 | < 0.1% |
| 129928 | 40 | < 0.1% |
| 115495 | 36 | < 0.1% |
| 31903 | 34 | < 0.1% |
| 97816 | 28 | < 0.1% |
| 47076 | 28 | < 0.1% |
| 15503 | 28 | < 0.1% |
| 203166 | 28 | < 0.1% |
| 28453 | 27 | < 0.1% |
| Other values (68143) | 189174 |
| Value | Count | Frequency (%) |
| 2 | 3 | |
| 3 | 1 | < 0.1% |
| 7 | 7 | |
| 10 | 3 | |
| 13 | 3 | |
| 17 | 1 | < 0.1% |
| 21 | 1 | < 0.1% |
| 22 | 2 | < 0.1% |
| 31 | 1 | < 0.1% |
| 35 | 3 |
| Value | Count | Frequency (%) |
| 206209 | 5 | |
| 206208 | 2 | < 0.1% |
| 206206 | 1 | < 0.1% |
| 206204 | 1 | < 0.1% |
| 206201 | 3 | |
| 206197 | 1 | < 0.1% |
| 206193 | 1 | < 0.1% |
| 206189 | 1 | < 0.1% |
| 206187 | 1 | < 0.1% |
| 206186 | 1 | < 0.1% |
order_number
Real number (ℝ)
High correlation 
| Distinct | 99 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18.203893 |
| Minimum | 2 |
|---|---|
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 6 |
| median | 12 |
| Q3 | 25 |
| 95-th percentile | 55 |
| Maximum | 100 |
| Range | 98 |
| Interquartile range (IQR) | 19 |
Descriptive statistics
| Standard deviation | 17.555727 |
|---|---|
| Coefficient of variation (CV) | 0.96439412 |
| Kurtosis | 3.1766306 |
| Mean | 18.203893 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 1.7399547 |
| Sum | 3449929 |
| Variance | 308.20356 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 12272 | 6.5% |
| 3 | 12133 | 6.4% |
| 4 | 11880 | 6.3% |
| 5 | 10556 | 5.6% |
| 6 | 9298 | 4.9% |
| 7 | 8560 | 4.5% |
| 8 | 7577 | 4.0% |
| 9 | 7052 | 3.7% |
| 10 | 6521 | 3.4% |
| 11 | 6266 | 3.3% |
| Other values (89) | 97401 |
| Value | Count | Frequency (%) |
| 2 | 12272 | |
| 3 | 12133 | |
| 4 | 11880 | |
| 5 | 10556 | |
| 6 | 9298 | |
| 7 | 8560 | |
| 8 | 7577 | |
| 9 | 7052 | |
| 10 | 6521 | |
| 11 | 6266 |
| Value | Count | Frequency (%) |
| 100 | 53 | |
| 99 | 47 | < 0.1% |
| 98 | 79 | |
| 97 | 92 | |
| 96 | 108 | |
| 95 | 71 | |
| 94 | 91 | |
| 93 | 97 | |
| 92 | 123 | |
| 91 | 81 |
order_dow
Real number (ℝ)
High correlation  Zeros 
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.7382279 |
| Minimum | 0 |
|---|---|
| Maximum | 6 |
| Zeros | 36565 |
| Zeros (%) | 19.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 6 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.0909175 |
|---|---|
| Coefficient of variation (CV) | 0.76360245 |
| Kurtosis | -1.3354969 |
| Mean | 2.7382279 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.17783666 |
| Sum | 518938 |
| Variance | 4.3719362 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 36565 | |
| 1 | 32668 | |
| 6 | 26156 | |
| 5 | 24908 | |
| 2 | 24802 | |
| 3 | 22478 | |
| 4 | 21939 |
| Value | Count | Frequency (%) |
| 0 | 36565 | |
| 1 | 32668 | |
| 2 | 24802 | |
| 3 | 22478 | |
| 4 | 21939 | |
| 5 | 24908 | |
| 6 | 26156 |
| Value | Count | Frequency (%) |
| 6 | 26156 | |
| 5 | 24908 | |
| 4 | 21939 | |
| 3 | 22478 | |
| 2 | 24802 | |
| 1 | 32668 | |
| 0 | 36565 |
order_hour_of_day
Real number (ℝ)
High correlation 
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.439678 |
| Minimum | 0 |
|---|---|
| Maximum | 23 |
| Zeros | 1271 |
| Zeros (%) | 0.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 7 |
| Q1 | 10 |
| median | 13 |
| Q3 | 16 |
| 95-th percentile | 21 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 4.2434462 |
|---|---|
| Coefficient of variation (CV) | 0.31574017 |
| Kurtosis | -0.020741059 |
| Mean | 13.439678 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.037719742 |
| Sum | 2547034 |
| Variance | 18.006835 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10 | 16215 | 8.6% |
| 11 | 16028 | 8.5% |
| 14 | 15840 | 8.4% |
| 15 | 15756 | 8.3% |
| 13 | 15513 | 8.2% |
| 12 | 15286 | 8.1% |
| 16 | 14704 | 7.8% |
| 9 | 14307 | 7.5% |
| 17 | 12100 | 6.4% |
| 8 | 9889 | 5.2% |
| Other values (14) | 43878 |
| Value | Count | Frequency (%) |
| 0 | 1271 | 0.7% |
| 1 | 663 | 0.3% |
| 2 | 349 | 0.2% |
| 3 | 284 | 0.1% |
| 4 | 279 | 0.1% |
| 5 | 566 | 0.3% |
| 6 | 1752 | 0.9% |
| 7 | 5184 | 2.7% |
| 8 | 9889 | |
| 9 | 14307 |
| Value | Count | Frequency (%) |
| 23 | 2356 | 1.2% |
| 22 | 3751 | 2.0% |
| 21 | 4661 | 2.5% |
| 20 | 5991 | 3.2% |
| 19 | 7288 | |
| 18 | 9483 | |
| 17 | 12100 | |
| 16 | 14704 | |
| 15 | 15756 | |
| 14 | 15840 |
days_since_prior_order
Real number (ℝ)
Zeros 
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.420603 |
| Minimum | 0 |
|---|---|
| Maximum | 30 |
| Zeros | 2723 |
| Zeros (%) | 1.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 5 |
| median | 8 |
| Q3 | 15 |
| 95-th percentile | 30 |
| Maximum | 30 |
| Range | 30 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 8.9802529 |
|---|---|
| Coefficient of variation (CV) | 0.78632038 |
| Kurtosis | -0.24566243 |
| Mean | 11.420603 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 0.99706993 |
| Sum | 2164387 |
| Variance | 80.644943 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 7 | 21367 | 11.3% |
| 30 | 21249 | 11.2% |
| 6 | 15625 | 8.2% |
| 5 | 12835 | 6.8% |
| 4 | 12417 | 6.6% |
| 8 | 11970 | 6.3% |
| 3 | 11293 | 6.0% |
| 2 | 8728 | 4.6% |
| 9 | 7591 | 4.0% |
| 14 | 6430 | 3.4% |
| Other values (21) | 60011 |
| Value | Count | Frequency (%) |
| 0 | 2723 | 1.4% |
| 1 | 5930 | 3.1% |
| 2 | 8728 | |
| 3 | 11293 | |
| 4 | 12417 | |
| 5 | 12835 | |
| 6 | 15625 | |
| 7 | 21367 | |
| 8 | 11970 | |
| 9 | 7591 | 4.0% |
| Value | Count | Frequency (%) |
| 30 | 21249 | |
| 29 | 1138 | 0.6% |
| 28 | 1701 | 0.9% |
| 27 | 1319 | 0.7% |
| 26 | 1100 | 0.6% |
| 25 | 1155 | 0.6% |
| 24 | 1295 | 0.7% |
| 23 | 1380 | 0.7% |
| 22 | 2002 | 1.1% |
| 21 | 2843 | 1.5% |
product_id
Real number (ℝ)
| Distinct | 134 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 71.096145 |
| Minimum | 1 |
|---|---|
| Maximum | 134 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 16 |
| Q1 | 31 |
| median | 83 |
| Q3 | 107 |
| 95-th percentile | 123 |
| Maximum | 134 |
| Range | 133 |
| Interquartile range (IQR) | 76 |
Descriptive statistics
| Standard deviation | 38.210891 |
|---|---|
| Coefficient of variation (CV) | 0.53745377 |
| Kurtosis | -1.3246676 |
| Mean | 71.096145 |
| Median Absolute Deviation (MAD) | 33 |
| Skewness | -0.16461665 |
| Sum | 13473857 |
| Variance | 1460.0722 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 24 | 21490 | 11.3% |
| 83 | 19909 | 10.5% |
| 123 | 10208 | 5.4% |
| 120 | 8567 | 4.5% |
| 21 | 5792 | 3.1% |
| 84 | 5375 | 2.8% |
| 115 | 4911 | 2.6% |
| 107 | 4172 | 2.2% |
| 91 | 3658 | 1.9% |
| 112 | 3364 | 1.8% |
| Other values (124) | 102070 |
| Value | Count | Frequency (%) |
| 1 | 413 | 0.2% |
| 2 | 472 | 0.2% |
| 3 | 2832 | |
| 4 | 1160 | |
| 5 | 363 | 0.2% |
| 6 | 209 | 0.1% |
| 7 | 192 | 0.1% |
| 8 | 197 | 0.1% |
| 9 | 1261 | |
| 10 | 52 | < 0.1% |
| Value | Count | Frequency (%) |
| 134 | 53 | < 0.1% |
| 133 | 104 | 0.1% |
| 132 | 35 | < 0.1% |
| 131 | 1563 | |
| 130 | 942 | |
| 129 | 1105 | |
| 128 | 1129 | |
| 127 | 245 | 0.1% |
| 126 | 101 | 0.1% |
| 125 | 236 | 0.1% |
add_to_cart_order
Real number (ℝ)
High correlation 
| Distinct | 84 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.3662857 |
| Minimum | 1 |
|---|---|
| Maximum | 135 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 6 |
| Q3 | 11 |
| 95-th percentile | 22 |
| Maximum | 135 |
| Range | 134 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 7.159101 |
|---|---|
| Coefficient of variation (CV) | 0.8557084 |
| Kurtosis | 6.4088486 |
| Mean | 8.3662857 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 1.8695087 |
| Sum | 1585545 |
| Variance | 51.252727 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 18691 | 9.9% |
| 2 | 17982 | 9.5% |
| 3 | 16621 | 8.8% |
| 4 | 15642 | 8.3% |
| 5 | 14338 | 7.6% |
| 6 | 12851 | 6.8% |
| 7 | 11585 | 6.1% |
| 8 | 10307 | 5.4% |
| 9 | 9222 | 4.9% |
| 10 | 7925 | 4.2% |
| Other values (74) | 54352 |
| Value | Count | Frequency (%) |
| 1 | 18691 | |
| 2 | 17982 | |
| 3 | 16621 | |
| 4 | 15642 | |
| 5 | 14338 | |
| 6 | 12851 | |
| 7 | 11585 | |
| 8 | 10307 | |
| 9 | 9222 | |
| 10 | 7925 |
| Value | Count | Frequency (%) |
| 135 | 1 | |
| 120 | 1 | |
| 93 | 2 | |
| 91 | 1 | |
| 90 | 2 | |
| 87 | 1 | |
| 85 | 1 | |
| 84 | 1 | |
| 78 | 2 | |
| 77 | 2 |
reordered
Categorical
High correlation 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 16.0 MiB |
| 1 | |
|---|---|
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 1 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 119155 | |
| 0 | 70361 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 119155 | |
| 0 | 70361 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 119155 | |
| 0 | 70361 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 189516 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 119155 | |
| 0 | 70361 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 189516 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 119155 | |
| 0 | 70361 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 189516 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 119155 | |
| 0 | 70361 |
department_id
Real number (ℝ)
High correlation 
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.9318158 |
| Minimum | 1 |
|---|---|
| Maximum | 21 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 9 |
| Q3 | 16 |
| 95-th percentile | 19 |
| Maximum | 21 |
| Range | 20 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 6.2830562 |
|---|---|
| Coefficient of variation (CV) | 0.63261909 |
| Kurtosis | -1.5613321 |
| Mean | 9.9318158 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 0.14969704 |
| Sum | 1882238 |
| Variance | 39.476796 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4 | 55392 | |
| 16 | 31697 | |
| 19 | 16986 | 9.0% |
| 7 | 15810 | 8.3% |
| 1 | 13005 | 6.9% |
| 13 | 10880 | 5.7% |
| 3 | 6843 | 3.6% |
| 15 | 6184 | 3.3% |
| 20 | 6093 | 3.2% |
| 9 | 5048 | 2.7% |
| Other values (11) | 21578 | 11.4% |
| Value | Count | Frequency (%) |
| 1 | 13005 | 6.9% |
| 2 | 209 | 0.1% |
| 3 | 6843 | 3.6% |
| 4 | 55392 | |
| 5 | 866 | 0.5% |
| 6 | 1553 | 0.8% |
| 7 | 15810 | 8.3% |
| 8 | 562 | 0.3% |
| 9 | 5048 | 2.7% |
| 10 | 204 | 0.1% |
| Value | Count | Frequency (%) |
| 21 | 461 | 0.2% |
| 20 | 6093 | 3.2% |
| 19 | 16986 | |
| 18 | 2463 | 1.3% |
| 17 | 4324 | 2.3% |
| 16 | 31697 | |
| 15 | 6184 | 3.3% |
| 14 | 4173 | 2.2% |
| 13 | 10880 | 5.7% |
| 12 | 4148 | 2.2% |
department
Categorical
High correlation 
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 17.2 MiB |
| produce | |
|---|---|
| dairy eggs | |
| snacks | |
| beverages | |
| frozen | |
| Other values (16) |
Length
| Max length | 15 |
|---|---|
| Median length | 13 |
| Mean length | 8.0003641 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | dairy eggs |
|---|---|
| 2nd row | canned goods |
| 3rd row | canned goods |
| 4th row | produce |
| 5th row | bakery |
Common Values
| Value | Count | Frequency (%) |
| produce | 55392 | |
| dairy eggs | 31697 | |
| snacks | 16986 | 9.0% |
| beverages | 15810 | 8.3% |
| frozen | 13005 | 6.9% |
| pantry | 10880 | 5.7% |
| bakery | 6843 | 3.6% |
| canned goods | 6184 | 3.3% |
| deli | 6093 | 3.2% |
| dry goods pasta | 5048 | 2.7% |
| Other values (11) | 21578 | 11.4% |
Length
| Value | Count | Frequency (%) |
| produce | 55392 | |
| dairy | 31697 | |
| eggs | 31697 | |
| snacks | 16986 | 7.0% |
| beverages | 15810 | 6.5% |
| frozen | 13005 | 5.3% |
| goods | 11232 | 4.6% |
| pantry | 10880 | 4.5% |
| bakery | 6843 | 2.8% |
| canned | 6184 | 2.5% |
| Other values (16) | 44530 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 193454 | |
| r | 149840 | 9.9% |
| a | 126803 | 8.4% |
| d | 124118 | 8.2% |
| s | 116966 | 7.7% |
| o | 113914 | 7.5% |
| g | 90897 | 6.0% |
| c | 82043 | 5.4% |
| p | 74497 | 4.9% |
| n | 60974 | 4.0% |
| Other values (13) | 382691 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1461457 | |
| Space Separator | 54740 | 3.6% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 193454 | |
| r | 149840 | |
| a | 126803 | 8.7% |
| d | 124118 | 8.5% |
| s | 116966 | 8.0% |
| o | 113914 | 7.8% |
| g | 90897 | 6.2% |
| c | 82043 | 5.6% |
| p | 74497 | 5.1% |
| n | 60974 | 4.2% |
| Other values (12) | 327951 |
Space Separator
| Value | Count | Frequency (%) |
| 54740 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1461457 | |
| Common | 54740 | 3.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 193454 | |
| r | 149840 | |
| a | 126803 | 8.7% |
| d | 124118 | 8.5% |
| s | 116966 | 8.0% |
| o | 113914 | 7.8% |
| g | 90897 | 6.2% |
| c | 82043 | 5.6% |
| p | 74497 | 5.1% |
| n | 60974 | 4.2% |
| Other values (12) | 327951 |
Common
| Value | Count | Frequency (%) |
| 54740 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1516197 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 193454 | |
| r | 149840 | 9.9% |
| a | 126803 | 8.4% |
| d | 124118 | 8.2% |
| s | 116966 | 7.7% |
| o | 113914 | 7.5% |
| g | 90897 | 6.0% |
| c | 82043 | 5.4% |
| p | 74497 | 4.9% |
| n | 60974 | 4.0% |
| Other values (13) | 382691 |
product_name
Text
| Distinct | 134 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 18.4 MiB |
Length
| Max length | 29 |
|---|---|
| Median length | 23 |
| Mean length | 14.420223 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | specialty cheeses |
|---|---|
| 2nd row | canned jarred vegetables |
| 3rd row | soup broth bouillon |
| 4th row | fresh fruits |
| 5th row | breakfast bakery |
| Value | Count | Frequency (%) |
| fresh | 45870 | 11.4% |
| vegetables | 31934 | 7.9% |
| fruits | 31794 | 7.9% |
| packaged | 18612 | 4.6% |
| frozen | 10068 | 2.5% |
| water | 9822 | 2.4% |
| yogurt | 8567 | 2.1% |
| ice | 5941 | 1.5% |
| cheese | 5792 | 1.4% |
| milk | 5375 | 1.3% |
| Other values (194) | 228628 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 389355 | |
| s | 258706 | 9.5% |
| r | 232201 | 8.5% |
| a | 214506 | 7.8% |
| 212887 | 7.8% | |
| t | 160486 | 5.9% |
| f | 118125 | 4.3% |
| i | 109651 | 4.0% |
| o | 102984 | 3.8% |
| g | 102195 | 3.7% |
| Other values (16) | 831767 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 2519976 | |
| Space Separator | 212887 | 7.8% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 389355 | |
| s | 258706 | 10.3% |
| r | 232201 | 9.2% |
| a | 214506 | 8.5% |
| t | 160486 | 6.4% |
| f | 118125 | 4.7% |
| i | 109651 | 4.4% |
| o | 102984 | 4.1% |
| g | 102195 | 4.1% |
| c | 97165 | 3.9% |
| Other values (15) | 734602 |
Space Separator
| Value | Count | Frequency (%) |
| 212887 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2519976 | |
| Common | 212887 | 7.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 389355 | |
| s | 258706 | 10.3% |
| r | 232201 | 9.2% |
| a | 214506 | 8.5% |
| t | 160486 | 6.4% |
| f | 118125 | 4.7% |
| i | 109651 | 4.4% |
| o | 102984 | 4.1% |
| g | 102195 | 4.1% |
| c | 97165 | 3.9% |
| Other values (15) | 734602 |
Common
| Value | Count | Frequency (%) |
| 212887 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2732863 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 389355 | |
| s | 258706 | 9.5% |
| r | 232201 | 8.5% |
| a | 214506 | 7.8% |
| 212887 | 7.8% | |
| t | 160486 | 5.9% |
| f | 118125 | 4.3% |
| i | 109651 | 4.0% |
| o | 102984 | 3.8% |
| g | 102195 | 3.7% |
| Other values (16) | 831767 |
day
Categorical
High correlation 
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 17.1 MiB |
| Monday | |
|---|---|
| Tuesday | |
| Sunday | |
| Saturday | |
| Wednesday | |
| Other values (2) |
Length
| Max length | 9 |
|---|---|
| Median length | 8 |
| Mean length | 7.0650605 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Wednesday |
|---|---|
| 2nd row | Thursday |
| 3rd row | Friday |
| 4th row | Friday |
| 5th row | Wednesday |
Common Values
| Value | Count | Frequency (%) |
| Monday | 36565 | |
| Tuesday | 32668 | |
| Sunday | 26156 | |
| Saturday | 24908 | |
| Wednesday | 24802 | |
| Thursday | 22478 | |
| Friday | 21939 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| monday | 36565 | |
| tuesday | 32668 | |
| sunday | 26156 | |
| saturday | 24908 | |
| wednesday | 24802 | |
| thursday | 22478 | |
| friday | 21939 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 214424 | |
| d | 214318 | |
| y | 189516 | |
| u | 106210 | |
| n | 87523 | |
| e | 82272 | 6.1% |
| s | 79948 | 6.0% |
| r | 69325 | 5.2% |
| T | 55146 | 4.1% |
| S | 51064 | 3.8% |
| Other values (7) | 189196 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1149426 | |
| Uppercase Letter | 189516 | 14.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 214424 | |
| d | 214318 | |
| y | 189516 | |
| u | 106210 | |
| n | 87523 | |
| e | 82272 | 7.2% |
| s | 79948 | 7.0% |
| r | 69325 | 6.0% |
| o | 36565 | 3.2% |
| t | 24908 | 2.2% |
| Other values (2) | 44417 | 3.9% |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 55146 | |
| S | 51064 | |
| M | 36565 | |
| W | 24802 | |
| F | 21939 | 11.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1338942 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 214424 | |
| d | 214318 | |
| y | 189516 | |
| u | 106210 | |
| n | 87523 | |
| e | 82272 | 6.1% |
| s | 79948 | 6.0% |
| r | 69325 | 5.2% |
| T | 55146 | 4.1% |
| S | 51064 | 3.8% |
| Other values (7) | 189196 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1338942 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 214424 | |
| d | 214318 | |
| y | 189516 | |
| u | 106210 | |
| n | 87523 | |
| e | 82272 | 6.1% |
| s | 79948 | 6.0% |
| r | 69325 | 5.2% |
| T | 55146 | 4.1% |
| S | 51064 | 3.8% |
| Other values (7) | 189196 |
order_time_list
Categorical
High correlation 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 17.1 MiB |
| Morning | |
|---|---|
| Afternoon | |
| Night | |
| Dawn | 5768 |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 7.3597269 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Afternoon |
|---|---|
| 2nd row | Afternoon |
| 3rd row | Night |
| 4th row | Morning |
| 5th row | Morning |
Common Values
| Value | Count | Frequency (%) |
| Morning | 78661 | |
| Afternoon | 73913 | |
| Night | 31174 | 16.4% |
| Dawn | 5768 | 3.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| morning | 78661 | |
| afternoon | 73913 | |
| night | 31174 | 16.4% |
| dawn | 5768 | 3.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 310916 | |
| o | 226487 | |
| r | 152574 | |
| i | 109835 | 7.9% |
| g | 109835 | 7.9% |
| t | 105087 | 7.5% |
| M | 78661 | 5.6% |
| A | 73913 | 5.3% |
| f | 73913 | 5.3% |
| e | 73913 | 5.3% |
| Other values (5) | 79652 | 5.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1205270 | |
| Uppercase Letter | 189516 | 13.6% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 310916 | |
| o | 226487 | |
| r | 152574 | |
| i | 109835 | 9.1% |
| g | 109835 | 9.1% |
| t | 105087 | 8.7% |
| f | 73913 | 6.1% |
| e | 73913 | 6.1% |
| h | 31174 | 2.6% |
| a | 5768 | 0.5% |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 78661 | |
| A | 73913 | |
| N | 31174 | 16.4% |
| D | 5768 | 3.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1394786 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 310916 | |
| o | 226487 | |
| r | 152574 | |
| i | 109835 | 7.9% |
| g | 109835 | 7.9% |
| t | 105087 | 7.5% |
| M | 78661 | 5.6% |
| A | 73913 | 5.3% |
| f | 73913 | 5.3% |
| e | 73913 | 5.3% |
| Other values (5) | 79652 | 5.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1394786 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| n | 310916 | |
| o | 226487 | |
| r | 152574 | |
| i | 109835 | 7.9% |
| g | 109835 | 7.9% |
| t | 105087 | 7.5% |
| M | 78661 | 5.6% |
| A | 73913 | 5.3% |
| f | 73913 | 5.3% |
| e | 73913 | 5.3% |
| Other values (5) | 79652 | 5.7% |
max_order
Real number (ℝ)
High correlation 
| Distinct | 99 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26.597153 |
| Minimum | 2 |
|---|---|
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 8 |
| median | 19 |
| Q3 | 39 |
| 95-th percentile | 78 |
| Maximum | 100 |
| Range | 98 |
| Interquartile range (IQR) | 31 |
Descriptive statistics
| Standard deviation | 23.092888 |
|---|---|
| Coefficient of variation (CV) | 0.86824661 |
| Kurtosis | 0.84836213 |
| Mean | 26.597153 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | 1.2140408 |
| Sum | 5040586 |
| Variance | 533.28146 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4 | 7982 | 4.2% |
| 3 | 7412 | 3.9% |
| 5 | 7332 | 3.9% |
| 2 | 6741 | 3.6% |
| 6 | 6601 | 3.5% |
| 7 | 6188 | 3.3% |
| 8 | 5718 | 3.0% |
| 9 | 5410 | 2.9% |
| 10 | 5031 | 2.7% |
| 11 | 5024 | 2.7% |
| Other values (89) | 126077 |
| Value | Count | Frequency (%) |
| 2 | 6741 | |
| 3 | 7412 | |
| 4 | 7982 | |
| 5 | 7332 | |
| 6 | 6601 | |
| 7 | 6188 | |
| 8 | 5718 | |
| 9 | 5410 | |
| 10 | 5031 | |
| 11 | 5024 |
| Value | Count | Frequency (%) |
| 100 | 323 | |
| 99 | 468 | |
| 98 | 535 | |
| 97 | 431 | |
| 96 | 526 | |
| 95 | 361 | |
| 94 | 352 | |
| 93 | 418 | |
| 92 | 352 | |
| 91 | 302 |
order_number_group
Categorical
High correlation 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 17.7 MiB |
| 1-20 order | |
|---|---|
| 21-40 order | |
| 41-60 order | |
| 61-80 order | |
| 81-100 order | 8210 |
Length
| Max length | 12 |
|---|---|
| Median length | 10 |
| Mean length | 10.523687 |
| Min length | 10 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1-20 order |
|---|---|
| 2nd row | 21-40 order |
| 3rd row | 21-40 order |
| 4th row | 41-60 order |
| 5th row | 21-40 order |
Common Values
| Value | Count | Frequency (%) |
| 1-20 order | 98479 | |
| 21-40 order | 47166 | |
| 41-60 order | 24558 | 13.0% |
| 61-80 order | 11103 | 5.9% |
| 81-100 order | 8210 | 4.3% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| order | 189516 | |
| 1-20 | 98479 | |
| 21-40 | 47166 | 12.4% |
| 41-60 | 24558 | 6.5% |
| 61-80 | 11103 | 2.9% |
| 81-100 | 8210 | 2.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 379032 | |
| 1 | 197726 | |
| 0 | 197726 | |
| - | 189516 | |
| 189516 | ||
| o | 189516 | |
| d | 189516 | |
| e | 189516 | |
| 2 | 145645 | 7.3% |
| 4 | 71724 | 3.6% |
| Other values (2) | 54974 | 2.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 947580 | |
| Decimal Number | 667795 | |
| Dash Punctuation | 189516 | 9.5% |
| Space Separator | 189516 | 9.5% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 197726 | |
| 0 | 197726 | |
| 2 | 145645 | |
| 4 | 71724 | 10.7% |
| 6 | 35661 | 5.3% |
| 8 | 19313 | 2.9% |
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 379032 | |
| o | 189516 | |
| d | 189516 | |
| e | 189516 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 189516 |
Space Separator
| Value | Count | Frequency (%) |
| 189516 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1046827 | |
| Latin | 947580 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 197726 | |
| 0 | 197726 | |
| - | 189516 | |
| 189516 | ||
| 2 | 145645 | |
| 4 | 71724 | 6.9% |
| 6 | 35661 | 3.4% |
| 8 | 19313 | 1.8% |
Latin
| Value | Count | Frequency (%) |
| r | 379032 | |
| o | 189516 | |
| d | 189516 | |
| e | 189516 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1994407 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| r | 379032 | |
| 1 | 197726 | |
| 0 | 197726 | |
| - | 189516 | |
| 189516 | ||
| o | 189516 | |
| d | 189516 | |
| e | 189516 | |
| 2 | 145645 | 7.3% |
| 4 | 71724 | 3.6% |
| Other values (2) | 54974 | 2.8% |
Cluster_DBSCAN
Categorical
High correlation 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 16.0 MiB |
| 0 | |
|---|---|
| 1 | |
| -1 | 37 |
Length
| Max length | 2 |
|---|---|
| Median length | 1 |
| Mean length | 1.0001952 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 0 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 119133 | |
| 1 | 70346 | |
| -1 | 37 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 119133 | |
| 1 | 70383 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 119133 | |
| 1 | 70383 | |
| - | 37 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 189516 | |
| Dash Punctuation | 37 | < 0.1% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 119133 | |
| 1 | 70383 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 37 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 189553 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 119133 | |
| 1 | 70383 | |
| - | 37 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 189553 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 119133 | |
| 1 | 70383 | |
| - | 37 | < 0.1% |
Interactions
Correlations
| Cluster_DBSCAN | add_to_cart_order | day | days_since_prior_order | department | department_id | max_order | order_dow | order_hour_of_day | order_id | order_number | order_number_group | order_time_list | product_id | reordered | user_id | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Cluster_DBSCAN | 1.000 | 0.513 | 0.013 | 0.100 | 0.152 | 0.120 | 0.174 | 0.013 | 0.040 | 0.006 | 0.195 | 0.153 | 0.033 | 0.069 | 1.000 | 0.007 |
| add_to_cart_order | 0.513 | 1.000 | 0.015 | 0.077 | 0.034 | 0.015 | -0.009 | -0.016 | -0.016 | -0.004 | -0.005 | 0.014 | 0.023 | 0.004 | 0.109 | 0.000 |
| day | 0.013 | 0.015 | 1.000 | 0.054 | 0.025 | 0.020 | 0.027 | 1.000 | 0.029 | 0.007 | 0.018 | 0.031 | 0.033 | 0.011 | 0.015 | 0.009 |
| days_since_prior_order | 0.100 | 0.077 | 0.054 | 1.000 | 0.019 | 0.003 | -0.493 | -0.042 | -0.006 | -0.001 | -0.386 | 0.266 | 0.032 | 0.004 | 0.141 | 0.001 |
| department | 0.152 | 0.034 | 0.025 | 0.019 | 1.000 | 1.000 | 0.021 | 0.025 | 0.014 | 0.002 | 0.018 | 0.030 | 0.017 | 0.438 | 0.215 | 0.006 |
| department_id | 0.120 | 0.015 | 0.020 | 0.003 | 1.000 | 1.000 | 0.008 | 0.005 | -0.011 | -0.004 | 0.003 | 0.022 | 0.013 | 0.022 | 0.169 | -0.000 |
| max_order | 0.174 | -0.009 | 0.027 | -0.493 | 0.021 | 0.008 | 1.000 | 0.020 | -0.048 | 0.002 | 0.780 | 0.975 | 0.029 | 0.001 | 0.246 | -0.006 |
| order_dow | 0.013 | -0.016 | 1.000 | -0.042 | 0.025 | 0.005 | 0.020 | 1.000 | 0.012 | 0.004 | 0.013 | 0.031 | 0.033 | 0.000 | 0.015 | 0.001 |
| order_hour_of_day | 0.040 | -0.016 | 0.029 | -0.006 | 0.014 | -0.011 | -0.048 | 0.012 | 1.000 | -0.001 | -0.038 | 0.031 | 0.836 | 0.002 | 0.036 | -0.001 |
| order_id | 0.006 | -0.004 | 0.007 | -0.001 | 0.002 | -0.004 | 0.002 | 0.004 | -0.001 | 1.000 | 0.004 | 0.006 | 0.007 | 0.000 | 0.000 | 0.004 |
| order_number | 0.195 | -0.005 | 0.018 | -0.386 | 0.018 | 0.003 | 0.780 | 0.013 | -0.038 | 0.004 | 1.000 | 0.552 | 0.025 | 0.001 | 0.275 | -0.005 |
| order_number_group | 0.153 | 0.014 | 0.031 | 0.266 | 0.030 | 0.022 | 0.975 | 0.031 | 0.031 | 0.006 | 0.552 | 1.000 | 0.027 | 0.020 | 0.216 | 0.018 |
| order_time_list | 0.033 | 0.023 | 0.033 | 0.032 | 0.017 | 0.013 | 0.029 | 0.033 | 0.836 | 0.007 | 0.025 | 0.027 | 1.000 | 0.009 | 0.023 | 0.009 |
| product_id | 0.069 | 0.004 | 0.011 | 0.004 | 0.438 | 0.022 | 0.001 | 0.000 | 0.002 | 0.000 | 0.001 | 0.020 | 0.009 | 1.000 | 0.098 | 0.002 |
| reordered | 1.000 | 0.109 | 0.015 | 0.141 | 0.215 | 0.169 | 0.246 | 0.015 | 0.036 | 0.000 | 0.275 | 0.216 | 0.023 | 0.098 | 1.000 | 0.000 |
| user_id | 0.007 | 0.000 | 0.009 | 0.001 | 0.006 | -0.000 | -0.006 | 0.001 | -0.001 | 0.004 | -0.005 | 0.018 | 0.009 | 0.002 | 0.000 | 1.000 |
Missing values
Sample
| order_id | user_id | order_number | order_dow | order_hour_of_day | days_since_prior_order | product_id | add_to_cart_order | reordered | department_id | department | product_name | day | order_time_list | max_order | order_number_group | Cluster_DBSCAN | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1083214 | 700028 | 169733 | 14 | 2 | 14 | 7.0 | 2 | 12 | 1 | 16 | dairy eggs | specialty cheeses | Wednesday | Afternoon | 14 | 1-20 order | 0 |
| 518295 | 2223185 | 199346 | 26 | 3 | 14 | 11.0 | 81 | 14 | 0 | 15 | canned goods | canned jarred vegetables | Thursday | Afternoon | 26 | 21-40 order | 1 |
| 112933 | 325694 | 126540 | 26 | 4 | 20 | 7.0 | 69 | 6 | 0 | 15 | canned goods | soup broth bouillon | Friday | Night | 26 | 21-40 order | 1 |
| 579731 | 1704510 | 8338 | 7 | 4 | 9 | 10.0 | 24 | 3 | 1 | 4 | produce | fresh fruits | Friday | Morning | 47 | 41-60 order | 0 |
| 780543 | 448953 | 10868 | 28 | 2 | 8 | 10.0 | 93 | 1 | 0 | 3 | bakery | breakfast bakery | Wednesday | Morning | 40 | 21-40 order | 1 |
| 1076747 | 1154159 | 149142 | 47 | 1 | 14 | 3.0 | 24 | 10 | 1 | 4 | produce | fresh fruits | Tuesday | Afternoon | 63 | 61-80 order | 0 |
| 1629667 | 72039 | 148916 | 5 | 5 | 10 | 4.0 | 120 | 2 | 1 | 16 | dairy eggs | yogurt | Saturday | Morning | 46 | 41-60 order | 0 |
| 97972 | 2304064 | 119252 | 5 | 1 | 15 | 8.0 | 52 | 18 | 1 | 1 | frozen | frozen breakfast | Tuesday | Afternoon | 5 | 1-20 order | 0 |
| 621931 | 765626 | 14737 | 38 | 5 | 12 | 7.0 | 26 | 15 | 1 | 7 | beverages | coffee | Saturday | Morning | 64 | 61-80 order | 0 |
| 581783 | 1479062 | 68668 | 8 | 0 | 16 | 15.0 | 83 | 17 | 1 | 4 | produce | fresh vegetables | Monday | Afternoon | 13 | 1-20 order | 0 |
| order_id | user_id | order_number | order_dow | order_hour_of_day | days_since_prior_order | product_id | add_to_cart_order | reordered | department_id | department | product_name | day | order_time_list | max_order | order_number_group | Cluster_DBSCAN | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 771967 | 1100412 | 152348 | 2 | 1 | 11 | 30.0 | 77 | 8 | 1 | 7 | beverages | soft drinks | Tuesday | Morning | 2 | 1-20 order | 0 |
| 1319657 | 2992007 | 113928 | 2 | 0 | 14 | 13.0 | 21 | 6 | 1 | 16 | dairy eggs | packaged cheese | Monday | Afternoon | 12 | 1-20 order | 0 |
| 1040485 | 3231589 | 100011 | 9 | 0 | 16 | 11.0 | 24 | 9 | 0 | 4 | produce | fresh fruits | Monday | Afternoon | 9 | 1-20 order | 1 |
| 74648 | 6262 | 124477 | 69 | 2 | 10 | 1.0 | 112 | 5 | 1 | 3 | bakery | bread | Wednesday | Morning | 100 | 81-100 order | 0 |
| 60733 | 19199 | 185247 | 17 | 6 | 14 | 30.0 | 77 | 9 | 0 | 7 | beverages | soft drinks | Sunday | Afternoon | 17 | 1-20 order | 1 |
| 1660186 | 2566034 | 96727 | 33 | 5 | 13 | 5.0 | 16 | 23 | 0 | 4 | produce | fresh herbs | Saturday | Afternoon | 33 | 21-40 order | 1 |
| 1426863 | 2845299 | 177992 | 24 | 1 | 16 | 8.0 | 59 | 11 | 1 | 15 | canned goods | canned meals beans | Tuesday | Afternoon | 24 | 21-40 order | 0 |
| 795781 | 2448063 | 119949 | 58 | 5 | 12 | 2.0 | 78 | 1 | 1 | 19 | snacks | crackers | Saturday | Morning | 58 | 41-60 order | 0 |
| 1254879 | 2963962 | 169312 | 11 | 5 | 9 | 4.0 | 20 | 9 | 0 | 11 | personal care | oral hygiene | Saturday | Morning | 11 | 1-20 order | 1 |
| 1758656 | 2421160 | 22593 | 15 | 0 | 8 | 29.0 | 83 | 11 | 1 | 4 | produce | fresh vegetables | Monday | Morning | 15 | 1-20 order | 0 |